No supported translation to SQL Help Linq -> SQL?
If orgAcrId is a List and r. GuidDivisionId is a uniqueidentifier column in SQL Server, this should be fine. Are you sure the column name isn't r.
DivisionId?
Yes it is a property of an object - public Guid guidDivisionId { get; set; }... var data = from r in db. TblRequirements where statusPreAward. Contains(r.
StrStatusId) && r.tblTeams. Any(x=>x. GuidPersonId == guidPersonId) select new PreAStatistics { other fiels are here but I don't have enough space, guidDivisionId = r.
TblOrganizationContracting. GuidOrgId }; – EvanGWatkins Oct 19 at 20:18 Is orgAcrId a List? – adrift Oct 19 at 20:19 Yes it is, and when I put a breakpoint on it I get 11 returned guids in the list (which is correct) – EvanGWatkins Oct 19 at 20:21.
Still, even if constructor calls are understood, calls to local methods may not be. If your final projection requires invocation of local methods, it is unlikely that LINQ to SQL will be able to oblige. Method calls that do not have a known translation into SQL cannot be used as part of the query.
One exception to this rule is method calls that have no arguments dependent on query variables. These are not considered part of the translated query and instead are treated as parameters. Still elaborate projections (transformations) may require local procedural logic to implement.
For you to use your own local methods in a final projection you will need to project twice.
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.
Related Questions
The member has no supported translation to SQL. When trying to access a property in my Partial class in the LINQ to SQL statement. Lamda expression?
Linq To SQL problem - has no supported translation to SQL (problem with C# property)?
The member [class] has no supported translation to SQL?
Method 'System.Object DynamicInvoke(System.Object[])' has no supported translation to SQL?
Help! help help help help help help help help?
The LINQ expression node type 'Invoke' is not supported in LINQ to Entities?